
create proc sp_getResourceInProducing
@resource_id int
as
select * from dbo.v_Storage_InProducing
where resource_Id =@resource_id and supply_unit_kg >usage
order by supply_HalfBarcode,supply_date